Microsoft Access Level 2

Outcomes

Participants build on the skills gained in Microsoft Access Level 1 to create a relational database system, use enhanced form design elements, use calculated queries and create customised reports.

Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.
Microsoft Access Level 1, or equivalent knowledge.

What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session

---

Principles of table design Normalizing data Normalizing data for fourth and fifth normal forms Principles of table relationships Analyzing table relationships Establishing and testing referential integrity Table design techniques Data validation techniques Indexing techniques Designing select queries Working with calculations Creating multiple-table queries

Enhanced form design Customizing the form design Adding calculations to a form Adding combo boxes to a form Adding unbound controls Subform design Creating a form that contains a subform Using the Form Wizard to create a form that contains a subform Customizing reports Customizing a report created by the Report Wizard Subreports Appendices Using the Chart Wizard Mailing labels